package com.yu.DAO;

import com.yu.POJO.Course;
import com.yu.POJO.Sc;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * Created with IntelliJ IDEA.
 *
 * @Author: LittleFisher
 * @Date: 2021/05/31/9:07
 * @Description:
 */
public interface ScDao {
    public List<Sc> getStuScByStu_Id(int id);
    public Sc CourseIsSelect(@Param("course_id")int course_id, @Param("stu_id")int stu_id);
    public int countCourse(int course_id);
    public int addSC(@Param("course_id")int course_id, @Param("stu_id")int stu_id);
    public List<Sc> getAllSC(@Param("start")int start, @Param("end")int end);
    public int upGrade(Sc sc);

    public List<Sc> getScByCourse_id(int course_id);

    public int getSCTotal();
}
